﻿/*

Version 0.0.3
Start Date : 22.11.2013

Db alters
*/

/*
ALTER TABLE `articles`
	ADD COLUMN `Publish_Start_Date` DATE NULL AFTER `Is_Draft`,
	ADD COLUMN `Publish_End_Date` DATE NULL AFTER `Publish_Start_Date`;

ALTER TABLE `settings`
	ADD COLUMN `Company_Name` VARCHAR(250) NULL AFTER `Art_Cnt_Per_Cat_On_Home`,
	ADD COLUMN `Tagline` VARCHAR(100) NULL AFTER `Company_Name`;

ALTER TABLE `settings`
	ADD COLUMN `Jumbotron_Text` VARCHAR(100) NULL AFTER `Tagline`;

ALTER TABLE `settings`
	ADD COLUMN `ShareThis_Pub_Key` VARCHAR(50) NULL AFTER `Jumbotron_Text`;

ALTER TABLE `articles`
	ADD FULLTEXT INDEX `Title_Content` (`Title`, `Content`);

ALTER TABLE `categories`
	ADD FULLTEXT INDEX `FullTextName` (`Name`);

CREATE TABLE `tags` (
	`id` BIGINT NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(200) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;

CREATE TABLE `article_tags` (
	`id` BIGINT NOT NULL AUTO_INCREMENT,
	`article_id` BIGINT NOT NULL,
	`tag_id` BIGINT NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;

ALTER TABLE `tags`
	ADD UNIQUE INDEX `name` (`name`);


*/
